TopMemoryContext - Configuration Mistake?

9-15">


I got the following error during a select query.



May it be a config error, or is it a bug?



TopMemoryContext: 186872 total in 15 blocks; 16544 free (41 chunks);
170328 used

=A0 TopTransactionContext: 8192 total in 1 blocks; 7568 free (0 chunks);
624 used

=A0 Type information cache: 24576 total in 2 blocks; 11888 free (5
chunks); 12688 used

=A0 Operator class cache: 8192 total in 1 blocks; 1680 free (0 chunks);
6512 used

=A0 Operator lookup cache: 24576 total in 2 blocks; 11888 free (5
chunks); 12688 used

=A0 MessageContext: 2042626048 total in 256 blocks; 16072 free (7
chunks); 2042609976 used

  =A0 JoinRelHashTable: 1040384 total in 7 blocks; 512384 free (12
chunks); 528000 used

=A0 smgr relation table: 24576 total in 2 blocks; 9776 free (4 chunks);
14800 used

=A0 TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0
chunks); 32 used

=A0 Portal hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used<=
br>
=A0 PortalMemory: 8192 total in 1 blocks; 8160 free (1 chunks); 32 used r>
=A0 Relcache by OID: 24576 total in 2 blocks; 12832 free (3 chunks);
11744 used

=A0 CacheMemoryContext: 2549344 total in 23 blocks; 986984 free (1
chunks); 1562360 used

  =A0 gen_porti_sched_pkey: 2048 total in 1 blocks; 656 free (0 chunk=
s);
1392 used

  =A0 m_zondes_pkey: 2048 total in 1 blocks; 704 free (0 chunks); 134=
4
used

  =A0 oevi_1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<=
br>
  =A0 oe_vessel_imbarco_pkey: 2048 total in 1 blocks; 632 free (0
chunks); 1416 used

  =A0 m_zonmar_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 129=
6
used

  =A0 m_tipmer_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 129=
6
used

  =A0 m_cianav_pkey: 2048 total in 1 blocks; 656 free (0 chunks); 139=
2
used

  =A0 oev_1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used r>
  =A0 oe_vessel_t_pkey: 2048 total in 1 blocks; 656 free (0 chunks); =
1392
used

  =A0 mmerca_cod_emb: 2048 total in 1 blocks; 752 free (0 chunks); 12=
96
used

  =A0 m_merca_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296=
used

  =A0 m_aeropu_pkey: 2048 total in 1 blocks; 704 free (0 chunks); 134=
4
used

  =A0 mcli_nome: 2048 total in 1 blocks; 752 free (0 chunks); 1296 us=
ed

  =A0 mcli_acro: 2048 total in 1 blocks; 752 free (0 chunks); 1296 us=
ed

  =A0 <m_cli_x1>: 2048 total in 1 blocks; 752 free (0 chunks); =
1296
used

  =A0 m_cli_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 u=
sed

  =A0 oec_2: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used r>
  =A0 oec_1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used r>
  =A0 oe_container_booking_nr_progr_ctnr_azienda_key: 2048 total in 1
blocks; 632 free (0 chunks); 1416 used

  =A0 oe_container_pkey: 2048 total in 1 blocks; 632 free (0 chunks);
1416 used

  =A0 oem_x1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<=
br>
  =A0 oe_sped_m_pkey: 2048 total in 1 blocks; 632 free (0 chunks); 14=
16
used

  =A0 ref_sales_pkey: 2048 total in 1 blocks; 440 free (0 chunks); 16=
08
used

  =A0 oes_x7: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<=
br>
  =A0 oes_x6: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<=
br>
  =A0 oes_x5: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<=
br>
  =A0 oes_x4: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<=
br>
  =A0 oes_x3: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<=
br>
  =A0 oes_x2: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<=
br>
  =A0 oes_x1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<=
br>
  =A0 oe_sped_t_pkey: 2048 total in 1 blocks; 656 free (0 chunks); 13=
92
used

  =A0 navig_save_pkey: 2048 total in 1 blocks; 656 free (0 chunks); 1=
392
used

  =A0 navig_fields_pkey: 2048 total in 1 blocks; 632 free (0 chunks);
1416 used

  =A0 navig_subarea_pkey: 2048 total in 1 blocks; 656 free (0 chunks)=
;
1392 used

  =A0 navig_area_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1=
296
used

  =A0 navig_left_table_pkey: 2048 total in 1 blocks; 752 free (0 chun=
ks);
1296 used

  =A0 gnp_cod_tipo_par: 2048 total in 1 blocks; 608 free (0 chunks); =
1440
used

  =A0 gen_param_pkey: 2048 total in 1 blocks; 632 free (0 chunks); 14=
16
used

  =A0 glchart_groups_pk_gr: 2048 total in 1 blocks; 752 free (0 chunk=
s);
1296 used

  =A0 pg_attrdef_oid_index: 2048 total in 1 blocks; 752 free (0 chunk=
s);
1296 used

  =A0 empresa_pkey: 2048 total in 1 blocks; 704 free (0 chunks); 1344=
used

  =A0 pg_attrdef_adrelid_adnum_index: 2048 total in 1 blocks; 608 fre=
e (0
chunks); 1440 used

  =A0 pg_index_indrelid_index: 2048 total in 1 blocks; 704 free (0
chunks); 1344 used

  =A0 pg_ts_dict_oid_index: 3072 total in 2 blocks; 1744 free (3 chun=
ks);
1328 used

  =A0 pg_aggregate_fnoid_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used

  =A0 pg_language_name_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used

  =A0 pg_statistic_relid_att_index: 3072 total in 2 blocks; 1600 free=
(2
chunks); 1472 used

  =A0 pg_ts_dict_dictname_index: 3072 total in 2 blocks; 1648 free (2
chunks); 1424 used

  =A0 pg_namespace_nspname_index: 3072 total in 2 blocks; 1696 free (=
2
chunks); 1376 used

  =A0 pg_opfamily_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used

  =A0 pg_opclass_oid_index: 3072 total in 2 blocks; 1696 free (2 chun=
ks);
1376 used

  =A0 pg_ts_parser_prsname_index: 3072 total in 2 blocks; 1648 free (=
2
chunks); 1424 used

  =A0 pg_amop_fam_strat_index: 3072 total in 2 blocks; 1384 free (2
chunks); 1688 used

  =A0 pg_opclass_am_name_nsp_index: 3072 total in 2 blocks; 1576 free=
(3
chunks); 1496 used

  =A0 pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1600 f=
ree
(2 chunks); 1472 used

  =A0 pg_cast_source_target_index: 3072 total in 2 blocks; 1600 free =
(2
chunks); 1472 used

  =A0 pg_auth_members_role_member_index: 3072 total in 2 blocks; 1648
free (2 chunks); 1424 used

  =A0 pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1600 f=
ree
(2 chunks); 1472 used

  =A0 pg_ts_config_cfgname_index: 3072 total in 2 blocks; 1648 free (=
2
chunks); 1424 used

  =A0 pg_authid_oid_index: 3072 total in 2 blocks; 1696 free (2 chunk=
s);
1376 used

  =A0 pg_ts_config_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used

  =A0 pg_conversion_default_index: 3072 total in 2 blocks; 1432 free =
(3
chunks); 1640 used

  =A0 pg_language_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used

  =A0 pg_enum_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks)=
;
1328 used

  =A0 pg_proc_proname_args_nsp_index: 3072 total in 2 blocks; 1576 fr=
ee
(3 chunks); 1496 used

  =A0 pg_ts_parser_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used

  =A0 pg_database_oid_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used

  =A0 pg_conversion_name_nsp_index: 3072 total in 2 blocks; 1648 free=
(2
chunks); 1424 used

  =A0 pg_class_relname_nsp_index: 3072 total in 2 blocks; 1600 free (=
2
chunks); 1472 used

  =A0 pg_attribute_relid_attnam_index: 3072 total in 2 blocks; 1648 f=
ree
(2 chunks); 1424 used

  =A0 pg_class_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks=
);
1376 used

  =A0 pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1384 free (2
chunks); 1688 used

  =A0 pg_operator_oprname_l_r_n_index: 3072 total in 2 blocks; 1384 f=
ree
(2 chunks); 1688 used

  =A0 pg_index_indexrelid_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used

  =A0 pg_type_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks)=
;
1376 used

  =A0 pg_rewrite_rel_rulename_index: 3072 total in 2 blocks; 1648 fre=
e (2
chunks); 1424 used

  =A0 pg_authid_rolname_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used

  =A0 pg_auth_members_member_role_index: 3072 total in 2 blocks; 1600
free (2 chunks); 1472 used

  =A0 pg_enum_typid_label_index: 3072 total in 2 blocks; 1648 free (2
chunks); 1424 used

  =A0 pg_constraint_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used

  =A0 pg_conversion_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used

  =A0 pg_ts_template_tmplname_index: 3072 total in 2 blocks; 1648 fre=
e (2
chunks); 1424 used

  =A0 pg_ts_config_map_index: 3072 total in 2 blocks; 1624 free (3
chunks); 1448 used

  =A0 pg_namespace_oid_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used

  =A0 pg_type_typname_nsp_index: 3072 total in 2 blocks; 1600 free (2
chunks); 1472 used

  =A0 pg_operator_oid_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used

  =A0 pg_amop_opr_fam_index: 3072 total in 2 blocks; 1600 free (2
chunks); 1472 used

  =A0 pg_proc_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks)=
;
1376 used

  =A0 pg_opfamily_am_name_nsp_index: 3072 total in 2 blocks; 1624 fre=
e (3
chunks); 1448 used

  =A0 pg_ts_template_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used

=A0 MdSmgr: 8192 total in 1 blocks; 5664 free (0 chunks); 2528 used

=A0 LOCALLOCK hash: 24576 total in 2 blocks; 15984 free (5 chunks); 8592
used

=A0 Timezones: 53584 total in 2 blocks; 3744 free (0 chunks); 49840 used<=
br>
=A0 ErrorContext: 24576 total in 3 blocks; 24480 free (18 chunks); 96 use=
d

2010-08-03 10:48:03 CEST [31005]: [658-1] ERROR:=A0 out of memory

 color=3D"#000000">Edoardo Innocenti

Infrastructure Coordinator
t>



SDB Information Technology

Phone: +39.055.3811222

Fax:   +39.055.5201411

Re: TopMemoryContext - Configuration Mistake?

Edoardo Innocenti writes:
> I got the following error during a select query.


What was the query, what does EXPLAIN show as the plan for it,
and which PG version is your server exactly?

>   MessageContext: 2042626048 total in 256 blocks; 16072 free (7
> chunks); 2042609976 used


This looks like it could be a memory leak, but we'd need to be able
to reproduce the problem in order to investigate or fix it.

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: TopMemoryContext - Configuration Mistake?

http-equiv=3D"Content-Type">


Il 16/08/2010 17:59, Tom Lane ha scritto:

Edoardo Innocenti 
f=3D"mailto:edoardo.innocenti@savinodelbene.com"><edoardo.innocenti@sa=

vinodelbene.com> writes:

  

I got the following error during a select query.<br=

>

    

What was the query, what does EXPLAIN show as the plan for it,

and which PG version is your server exactly?



  

=A0 MessageContext: 2042626048 total in 256 blocks; 16=

072 free (7

chunks); 2042609976 used<br>

    

This looks like it could be a memory leak, but we'd need to be able

to reproduce the problem in order to investigate or fix it.



  

			regards, tom lane



  

 color=3D"#000000">Edoardo Innocenti

Infrastructure Coordinator
t>



SDB Information Technology

Phone: +39.055.3811222

Fax:   +39.055.5201411

Re: TopMemoryContext - Configuration Mistake?

Edoardo Innocenti writes:
> Query Plan:

> "HashAggregate (cost=4910.06..4910.19 rows=1 width=659)"

Hm ... the planner seems to think that this is a small query that isn't
going to take long, which is a bit at odds with the fact that you're
running out of memory. I suspect that these rowcount estimates are
far too low, which would suggest that you need to make sure your
ANALYZE statistics are up-to-date, and perhaps raise the statistics
targets. Try to get the plan's estimated rowcounts to approximate
reality.

BTW, you might want to think about turning off your mail program's
HTML option. What other people are seeing looks like this:
http://archives.postgresql.org/pgsql-admin/2010-08/msg00126. php
and it's not pretty.

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: TopMemoryContext - Configuration Mistake?

http-equiv="Content-Type">


Il 17/08/2010 15:44, Tom Lane ha scritto:

Edoardo Innocenti  writes:

  

Query Plan:<br>

"HashAggregate (cost=4910.06..4910.19 rows=1 width=659)"

    

Hm ... the planner seems to think that this is a small query that isn't

going to take long, which is a bit at odds with the fact that you're

running out of memory.  I suspect that these rowcount estimates are

far too low, which would suggest that you need to make sure your

ANALYZE statistics are up-to-date, and perhaps raise the statistics

targets.  Try to get the plan's estimated rowcounts to approximate

reality.



  

BTW, you might want to think about turning off your mail program's

HTML option.  What other people are seeing looks like this:



and it's not pretty.



			regards, tom lane



  

 color="#000000">Edoardo Innocenti

Infrastructure Coordinator



SDB Information Technology

Phone: +39.055.3811222

Fax:   +39.055.5201411